﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DAL;
using DTO;

namespace BUS
{
    public class NhanVienBUS
    {
        NhanVienDAO NV_DAO = new NhanVienDAO();
        public void khoitao_KN()
        {
            SqlConnection conn = new SqlConnection();
            conn = NV_DAO.khoitaoKN();
        }
        public string Phatsinh_MaNV()
        {
            return NV_DAO.Phatsinh_manv();
        }
        public void them_nhanVien(NhanVienDTO NV_DTO)
        {
            NV_DAO.themNhanVien(NV_DTO);
        }
        public void xoa_NhanVien(NhanVienDTO NV_DTO)
        {
            NV_DAO.xoaNhanVien(NV_DTO);
        }
        public void Sus_NhanVien(NhanVienDTO NV_DTO)
        {
            NV_DAO.Sua_NhanVien(NV_DTO);
        }
        public DataTable Hien_DSNV()
        {
            return NV_DAO.HienThi_DSNV();
        }
        public DataTable TimKiem_MaNV(string manv)
        {
            return NV_DAO.TimKiemTheoMaNV(manv);
        }
        public DataTable TimKiem_TheoMaNV(string tennv)
        {
            return NV_DAO.TimKiemTheoTen(tennv);
        }
        public DataTable TimKiem_theotenNV(string tennv)
        {
            return NV_DAO.TimKiemTheoTen(tennv);
        }



        //----------------------thu a

        public DataTable insert()
        {
            return NV_DAO.Import_FromEXcel();
        }



    }
}
 
